/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 80027
 Source Host           : localhost:3306
 Source Schema         : 2002a_rbac

 Target Server Type    : MySQL
 Target Server Version : 80027
 File Encoding         : 65001

 Date: 09/05/2022 14:14:07
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(30) COLLATE utf8mb4_german2_ci DEFAULT NULL COMMENT '用户名',
  `password` varchar(32) COLLATE utf8mb4_german2_ci DEFAULT NULL COMMENT '密码',
  `login_at` int DEFAULT NULL COMMENT '登录时间',
  `status` tinyint(1) DEFAULT '0' COMMENT '管理员状态 0 正常 1 禁用',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_german2_ci;

-- ----------------------------
-- Records of admin
-- ----------------------------
BEGIN;
INSERT INTO `admin` VALUES (1, 'admin', 'e10adc3949ba59abbe56e057f20f883e', NULL, 0);
INSERT INTO `admin` VALUES (2, '李四', 'e10adc3949ba59abbe56e057f20f883e', NULL, 0);
COMMIT;

-- ----------------------------
-- Table structure for admin_role
-- ----------------------------
DROP TABLE IF EXISTS `admin_role`;
CREATE TABLE `admin_role` (
  `admin_id` int DEFAULT NULL COMMENT '用户id',
  `role_id` int DEFAULT NULL COMMENT '角色id'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_german2_ci;

-- ----------------------------
-- Records of admin_role
-- ----------------------------
BEGIN;
INSERT INTO `admin_role` VALUES (1, 1);
INSERT INTO `admin_role` VALUES (2, 2);
COMMIT;

-- ----------------------------
-- Table structure for auth
-- ----------------------------
DROP TABLE IF EXISTS `auth`;
CREATE TABLE `auth` (
  `id` int NOT NULL AUTO_INCREMENT,
  `auth_name` varchar(30) COLLATE utf8mb4_german2_ci DEFAULT NULL COMMENT '权限名称',
  `controller` varchar(30) COLLATE utf8mb4_german2_ci DEFAULT NULL COMMENT '控制器名',
  `action` varchar(30) COLLATE utf8mb4_german2_ci DEFAULT NULL COMMENT '方法名',
  `is_nav` tinyint(1) DEFAULT '0' COMMENT '是否是菜单 0 不是 1 是',
  `parent_id` int DEFAULT '0' COMMENT '父级id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_german2_ci;

-- ----------------------------
-- Records of auth
-- ----------------------------
BEGIN;
INSERT INTO `auth` VALUES (1, '创建用户', 'Admin', 'create', 0, 5);
INSERT INTO `auth` VALUES (2, '删除用户', 'Admin', 'delete', 0, 5);
INSERT INTO `auth` VALUES (3, '修改密码', 'Admin', 'updatePassword', 0, 5);
INSERT INTO `auth` VALUES (4, '查看信息', 'Admin', 'getInfo', 0, 5);
INSERT INTO `auth` VALUES (5, '用户管理', NULL, NULL, 1, 0);
INSERT INTO `auth` VALUES (6, '商品管理', NULL, NULL, 1, 0);
INSERT INTO `auth` VALUES (7, '系统管理', NULL, NULL, 1, 0);
INSERT INTO `auth` VALUES (8, '添加商品', 'Goods', 'add', 0, 6);
COMMIT;

-- ----------------------------
-- Table structure for category
-- ----------------------------
DROP TABLE IF EXISTS `category`;
CREATE TABLE `category` (
  `id` smallint unsigned NOT NULL AUTO_INCREMENT COMMENT '商品分类id',
  `cate_name` varchar(90) NOT NULL DEFAULT '' COMMENT '商品分类名称',
  `pid` smallint unsigned NOT NULL DEFAULT '0' COMMENT '父id',
  `pid_path` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '' COMMENT '家族图谱',
  `pid_path_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '' COMMENT '家族图片分类名',
  `level` tinyint(1) DEFAULT '0' COMMENT '等级',
  `sort` tinyint unsigned NOT NULL DEFAULT '50' COMMENT '顺序排序',
  `is_show` tinyint unsigned NOT NULL DEFAULT '1' COMMENT '是否显示',
  `image_url` varchar(512) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '' COMMENT '分类图片',
  `is_hot` tinyint(1) DEFAULT '0' COMMENT '是否推荐为热门分类',
  `create_time` int DEFAULT NULL,
  `update_time` int DEFAULT NULL,
  `delete_time` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `parent_id` (`pid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=817 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of category
-- ----------------------------
BEGIN;
INSERT INTO `category` VALUES (1, '家用电器', 0, '0', '', 0, 50, 1, '', 0, 1559054127, 1559054127, NULL);
INSERT INTO `category` VALUES (2, '手机/运营商/数码', 0, '0', '', 0, 50, 1, '', 0, 1559054127, 1559054127, NULL);
INSERT INTO `category` VALUES (3, '电脑/办公', 0, '0', '', 0, 50, 1, '', 0, 1559054127, 1559054127, NULL);
INSERT INTO `category` VALUES (4, '家居/家具/家装/厨具', 0, '0', '', 0, 50, 1, '', 0, 1559054127, 1559054127, NULL);
INSERT INTO `category` VALUES (5, '男装/女装/童装/内衣', 0, '0', '', 0, 50, 1, '', 0, 1559054127, 1559054127, NULL);
INSERT INTO `category` VALUES (6, '美妆/个护清洁/宠物', 0, '0', '', 0, 50, 1, '', 0, 1559054127, 1559054127, NULL);
INSERT INTO `category` VALUES (7, '女鞋/箱包/钟表/珠宝', 0, '0', '', 0, 50, 1, '', 0, 1559054127, 1559054127, NULL);
INSERT INTO `category` VALUES (8, '男鞋/运动/户外', 0, '0', '', 0, 50, 1, '', 0, 1559054127, 1559054127, NULL);
INSERT INTO `category` VALUES (9, '房产/汽车/汽车用品', 0, '0', '', 0, 50, 1, '', 0, 1559054127, 1559054127, NULL);
INSERT INTO `category` VALUES (10, '母婴/玩具乐器', 0, '0', '', 0, 50, 1, '', 0, 1559054127, 1559054127, NULL);
INSERT INTO `category` VALUES (11, '食品/酒类/生鲜/特产', 0, '0', '', 0, 50, 1, '', 0, 1559054127, 1559054127, NULL);
INSERT INTO `category` VALUES (12, '艺术/礼品鲜花/农资绿植', 0, '0', '', 0, 50, 1, '', 0, 1559054127, 1559054127, NULL);
INSERT INTO `category` VALUES (13, '医药保健/计生情趣', 0, '0', '', 0, 50, 1, '', 0, 1559054127, 1559054127, NULL);
INSERT INTO `category` VALUES (14, '图书/文娱/电子书', 0, '0', '', 0, 50, 1, '', 0, 1559054127, 1559054127, NULL);
INSERT INTO `category` VALUES (15, '机票/酒店/旅游/生活', 0, '0', '', 0, 50, 1, '', 0, 1559054127, 1559054127, NULL);
INSERT INTO `category` VALUES (16, '电视', 1, '0_1', '家用电器', 1, 50, 1, '', 0, 1559054127, 1559054127, NULL);
INSERT INTO `category` VALUES (17, '超薄电视', 16, '0_1_16', '家用电器_电视', 2, 50, 1, '', 0, 1559054127, 1559054127, NULL);
INSERT INTO `category` VALUES (18, '全面屏电视', 16, '0_1_16', '家用电器_电视', 2, 50, 1, '', 0, 1559054127, 1559054127, NULL);
INSERT INTO `category` VALUES (19, '智能电视', 16, '0_1_16', '家用电器_电视', 2, 50, 1, '', 0, 1559054127, 1559054127, NULL);
INSERT INTO `category` VALUES (20, 'OLED电视', 16, '0_1_16', '家用电器_电视', 2, 50, 1, '', 0, 1559054127, 1559054127, NULL);
INSERT INTO `category` VALUES (21, '曲面电视', 16, '0_1_16', '家用电器_电视', 2, 50, 1, '', 0, 1559054127, 1559054127, NULL);
INSERT INTO `category` VALUES (22, '4K超清电视', 16, '0_1_16', '家用电器_电视', 2, 50, 1, '', 0, 1559054127, 1559054127, NULL);
INSERT INTO `category` VALUES (23, '55英寸', 16, '0_1_16', '家用电器_电视', 2, 50, 1, '', 0, 1559054127, 1559054127, NULL);
INSERT INTO `category` VALUES (24, '65英寸', 16, '0_1_16', '家用电器_电视', 2, 50, 1, '', 0, 1559054127, 1559054127, NULL);
INSERT INTO `category` VALUES (25, '电视配件', 16, '0_1_16', '家用电器_电视', 2, 50, 1, '', 0, 1559054127, 1559054127, NULL);
INSERT INTO `category` VALUES (26, '空调', 1, '0_1', '家用电器', 1, 50, 1, '', 0, 1559054127, 1559054127, NULL);
INSERT INTO `category` VALUES (27, '空调挂机', 26, '0_1_26', '家用电器_空调', 2, 50, 1, '', 0, 1559054127, 1559054127, NULL);
INSERT INTO `category` VALUES (28, '空调柜机', 26, '0_1_26', '家用电器_空调', 2, 50, 1, '', 0, 1559054127, 1559054127, NULL);
INSERT INTO `category` VALUES (29, '精选推荐', 26, '0_1_26', '家用电器_空调', 2, 50, 1, '', 0, 1559054127, 1559054127, NULL);
INSERT INTO `category` VALUES (30, '中央空调', 26, '0_1_26', '家用电器_空调', 2, 50, 1, '', 0, 1559054127, 1559054127, NULL);
INSERT INTO `category` VALUES (31, '移动空调', 26, '0_1_26', '家用电器_空调', 2, 50, 1, '', 0, 1559054127, 1559054127, NULL);
INSERT INTO `category` VALUES (32, '省电空调', 26, '0_1_26', '家用电器_空调', 2, 50, 1, '', 0, 1559054127, 1559054127, NULL);
INSERT INTO `category` VALUES (33, '变频空调', 26, '0_1_26', '家用电器_空调', 2, 50, 1, '', 0, 1559054127, 1559054127, NULL);
INSERT INTO `category` VALUES (34, '洗衣机', 1, '0_1', '家用电器', 1, 50, 1, '', 0, 1559054127, 1559054127, NULL);
INSERT INTO `category` VALUES (35, '滚筒洗衣机', 34, '0_1_34', '家用电器_洗衣机', 2, 50, 1, '', 0, 1559054127, 1559054127, NULL);
INSERT INTO `category` VALUES (36, '洗烘一体机', 34, '0_1_34', '家用电器_洗衣机', 2, 50, 1, '', 0, 1559054127, 1559054127, NULL);
INSERT INTO `category` VALUES (37, '波轮洗衣机', 34, '0_1_34', '家用电器_洗衣机', 2, 50, 1, '', 0, 1559054127, 1559054127, NULL);
INSERT INTO `category` VALUES (38, '迷你洗衣机', 34, '0_1_34', '家用电器_洗衣机', 2, 50, 1, '', 0, 1559054127, 1559054127, NULL);
INSERT INTO `category` VALUES (39, '烘干机', 34, '0_1_34', '家用电器_洗衣机', 2, 50, 1, '', 0, 1559054127, 1559054127, NULL);
INSERT INTO `category` VALUES (40, '洗衣机配件', 34, '0_1_34', '家用电器_洗衣机', 2, 50, 1, '', 0, 1559054127, 1559054127, NULL);
INSERT INTO `category` VALUES (41, '冰箱', 1, '0_1', '家用电器', 1, 50, 1, '', 0, 1559054127, 1559054127, NULL);
INSERT INTO `category` VALUES (42, '多门', 41, '0_1_41', '家用电器_冰箱', 2, 50, 1, '', 0, 1559054127, 1559054127, NULL);
INSERT INTO `category` VALUES (43, '对开门', 41, '0_1_41', '家用电器_冰箱', 2, 50, 1, '', 0, 1559054127, 1559054127, NULL);
INSERT INTO `category` VALUES (44, '三门', 41, '0_1_41', '家用电器_冰箱', 2, 50, 1, '', 0, 1559054127, 1559054127, NULL);
INSERT INTO `category` VALUES (45, '双门', 41, '0_1_41', '家用电器_冰箱', 2, 50, 1, '', 0, 1559054127, 1559054127, NULL);
INSERT INTO `category` VALUES (46, '冷柜/冰吧', 41, '0_1_41', '家用电器_冰箱', 2, 50, 1, '', 0, 1559054127, 1559054127, NULL);
INSERT INTO `category` VALUES (47, '酒柜', 41, '0_1_41', '家用电器_冰箱', 2, 50, 1, '', 0, 1559054127, 1559054127, NULL);
INSERT INTO `category` VALUES (48, '冰箱配件', 41, '0_1_41', '家用电器_冰箱', 2, 50, 1, '', 0, 1559054127, 1559054127, NULL);
INSERT INTO `category` VALUES (49, '厨卫大电', 1, '0_1', '家用电器', 1, 50, 1, '', 0, 1559054127, 1559054127, NULL);
INSERT INTO `category` VALUES (50, '油烟机', 49, '0_1_49', '家用电器_厨卫大电', 2, 50, 1, '', 0, 1559054127, 1559054127, NULL);
INSERT INTO `category` VALUES (51, '燃气灶', 49, '0_1_49', '家用电器_厨卫大电', 2, 50, 1, '', 0, 1559054127, 1559054127, NULL);
INSERT INTO `category` VALUES (52, '烟灶套装', 49, '0_1_49', '家用电器_厨卫大电', 2, 50, 1, '', 0, 1559054127, 1559054127, NULL);
INSERT INTO `category` VALUES (53, '集成灶', 49, '0_1_49', '家用电器_厨卫大电', 2, 50, 1, '', 0, 1559054127, 1559054127, NULL);
INSERT INTO `category` VALUES (54, '消毒柜', 49, '0_1_49', '家用电器_厨卫大电', 2, 50, 1, '', 0, 1559054127, 1559054127, NULL);
COMMIT;

-- ----------------------------
-- Table structure for goods
-- ----------------------------
DROP TABLE IF EXISTS `goods`;
CREATE TABLE `goods` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `goods_name` varchar(255) NOT NULL DEFAULT '' COMMENT '商品名称',
  `goods_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '商品价格',
  `market_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '市场价',
  `cost_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '成本价',
  `goods_number` int unsigned NOT NULL DEFAULT '100' COMMENT '商品数量',
  `frozen_number` int DEFAULT '0' COMMENT '冻结数量',
  `goods_remark` varchar(255) NOT NULL DEFAULT '' COMMENT '商品简单描述',
  `goods_desc` text COMMENT '详细介绍',
  `goods_logo` varchar(255) NOT NULL DEFAULT '' COMMENT '商品logo图',
  `type_id` int unsigned NOT NULL DEFAULT '0' COMMENT '商品类型id',
  `brand_id` int NOT NULL DEFAULT '0' COMMENT '品牌id',
  `cate_id` int unsigned NOT NULL DEFAULT '0' COMMENT '商品分类id',
  `mould_id` int DEFAULT '0' COMMENT '运费模板id  1以件计算; 2以重量计算; 3以体积计算',
  `weight` int DEFAULT NULL COMMENT '商品重量，以克为单位',
  `volume` double(10,2) DEFAULT NULL COMMENT '商品体积，以立方米为单位',
  `keywords` varchar(255) NOT NULL DEFAULT '' COMMENT '关键词',
  `comments_num` int NOT NULL DEFAULT '0' COMMENT '评论数',
  `collect_num` varchar(255) NOT NULL DEFAULT '0' COMMENT '收藏数',
  `sales_num` int NOT NULL DEFAULT '0' COMMENT '销量',
  `is_on_sale` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否上架；1是0否',
  `is_free_shipping` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否包邮；1是0否',
  `is_recommend` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否推荐；1是0否',
  `is_new` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否新品;1是0否',
  `is_hot` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否热卖；1是0否',
  `sort` smallint NOT NULL DEFAULT '50' COMMENT '排序',
  `suppliers_id` smallint NOT NULL COMMENT '供货商',
  `goods_attr` varchar(255) DEFAULT NULL COMMENT '商品属性值：json串',
  `create_time` int unsigned NOT NULL COMMENT '添加时间',
  `update_time` int unsigned NOT NULL COMMENT '修改时间',
  `delete_time` int unsigned DEFAULT NULL COMMENT '软删除时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of goods
-- ----------------------------
BEGIN;
INSERT INTO `goods` VALUES (1, '荣耀10青春版 幻彩渐变 2400万AI自拍 全网通版4GB+64GB 渐变蓝 移动联通电信4G全面屏手机 双卡双待', 5299.00, 5299.00, 5299.00, 100, 0, '', NULL, '/uploads/goods/20190528/865565d919219154.jpg', 0, 1, 21, 0, NULL, NULL, '', 0, '0', 0, 1, 1, 1, 1, 1, 50, 0, '[{\"id\":\"7\",\"attr_name\":\"毛重\",\"attr_value\":\"180g\"},{\"id\":\"8\",\"attr_name\":\"产地\",\"attr_value\":\"中国\"}]', 1559054211, 1559054211, NULL);
INSERT INTO `goods` VALUES (2, '小米 红米Redmi Note7 幻彩渐变AI双摄 4GB+64GB 梦幻蓝 全网通4G 双卡双待 水滴全面屏拍照游戏智能手机', 6299.00, 6299.00, 6299.00, 100, 0, '', NULL, '/uploads/goods/20190528/4f4ba51aed682207.jpg', 0, 2, 21, 0, NULL, NULL, '', 0, '0', 0, 1, 1, 1, 1, 1, 50, 0, '[{\"id\":\"7\",\"attr_name\":\"毛重\",\"attr_value\":\"180g\"},{\"id\":\"8\",\"attr_name\":\"产地\",\"attr_value\":\"中国\"}]', 1559054211, 1559054211, NULL);
INSERT INTO `goods` VALUES (3, '荣耀V20 胡歌同款 麒麟980芯片 魅眼全视屏 4800万深感相机 6GB+128GB 幻夜黑 移动联通电信4G全面屏手机', 1299.00, 1299.00, 1299.00, 100, 0, '', NULL, '/uploads/goods/20190528/5a38e39b2975e837.jpg', 0, 1, 21, 0, NULL, NULL, '', 0, '0', 0, 1, 1, 1, 1, 1, 50, 0, '[{\"id\":\"7\",\"attr_name\":\"毛重\",\"attr_value\":\"180g\"},{\"id\":\"8\",\"attr_name\":\"产地\",\"attr_value\":\"中国\"}]', 1559054211, 1559054211, NULL);
INSERT INTO `goods` VALUES (4, '华为 HUAWEI P30 Pro 超感光徕卡四摄10倍混合变焦麒麟980芯片屏内指纹 8GB+256GB亮黑色全网通版双4G手机', 2999.00, 2999.00, 2999.00, 100, 0, '', NULL, '/uploads/goods/20190528/295353ae7701c622.jpg', 0, 1, 21, 0, NULL, NULL, '', 0, '0', 0, 1, 1, 1, 1, 1, 50, 0, '[{\"id\":\"7\",\"attr_name\":\"毛重\",\"attr_value\":\"180g\"},{\"id\":\"8\",\"attr_name\":\"产地\",\"attr_value\":\"中国\"}]', 1559054211, 1559054211, NULL);
INSERT INTO `goods` VALUES (5, 'Apple iPhone XR (A2108) 128GB 黑色 移动联通电信4G手机 双卡双待', 9099.00, 9099.00, 9099.00, 100, 0, '', NULL, '/uploads/goods/20190528/02a76e957253a541.jpg', 0, 3, 21, 0, NULL, NULL, '', 0, '0', 0, 1, 1, 1, 1, 1, 50, 0, '[{\"id\":\"7\",\"attr_name\":\"毛重\",\"attr_value\":\"180g\"},{\"id\":\"8\",\"attr_name\":\"产地\",\"attr_value\":\"中国\"}]', 1559054211, 1559054211, NULL);
INSERT INTO `goods` VALUES (6, '小米8SE 全面屏智能游戏拍照手机 6GB+64GB 灰色 骁龙710处理器 全网通4G 双卡双待', 4899.00, 4899.00, 4899.00, 100, 0, '', NULL, '/uploads/goods/20190528/5b0fbaabN3229c7a3.jpg', 0, 2, 21, 0, NULL, NULL, '', 0, '0', 0, 1, 1, 1, 1, 1, 50, 0, '[{\"id\":\"7\",\"attr_name\":\"毛重\",\"attr_value\":\"180g\"},{\"id\":\"8\",\"attr_name\":\"产地\",\"attr_value\":\"中国\"}]', 1559054211, 1559054211, NULL);
INSERT INTO `goods` VALUES (7, 'Apple iPhone 8 (A1863) 64GB 深空灰色 移动联通电信4G手机', 3799.00, 3799.00, 3799.00, 100, 0, '', NULL, '/uploads/goods/20190528/59b85824N836bb714.jpg', 0, 3, 21, 0, NULL, NULL, '', 0, '0', 0, 1, 1, 1, 1, 1, 50, 0, '[{\"id\":\"7\",\"attr_name\":\"毛重\",\"attr_value\":\"180g\"},{\"id\":\"8\",\"attr_name\":\"产地\",\"attr_value\":\"中国\"}]', 1559054211, 1559054211, NULL);
INSERT INTO `goods` VALUES (8, '荣耀8X 千元屏霸 91%屏占比 2000万AI双摄 4GB+64GB 幻夜黑 移动联通电信4G全面屏手机 双卡双待', 2499.00, 2499.00, 2499.00, 100, 0, '', NULL, '/uploads/goods/20190528/c16e93d0bf77a31f.jpg', 0, 1, 21, 0, NULL, NULL, '', 0, '0', 0, 1, 1, 1, 1, 1, 50, 0, '[{\"id\":\"7\",\"attr_name\":\"毛重\",\"attr_value\":\"180g\"},{\"id\":\"8\",\"attr_name\":\"产地\",\"attr_value\":\"中国\"}]', 1559054211, 1559054211, NULL);
INSERT INTO `goods` VALUES (9, '华为 HUAWEI P30 超感光徕卡三摄麒麟980AI智能芯片全面屏屏内指纹版手机8GB+128GB天空之境全网通双4G手机', 6999.00, 6999.00, 6999.00, 100, 0, '', NULL, '/uploads/goods/20190528/8ecf0cb424de1349.jpg', 0, 1, 72, 0, NULL, NULL, '', 0, '0', 0, 1, 1, 1, 1, 1, 50, 0, '[{\"id\":\"7\",\"attr_name\":\"毛重\",\"attr_value\":\"180g\"},{\"id\":\"8\",\"attr_name\":\"产地\",\"attr_value\":\"中国\"}]', 1559054211, 1559054211, NULL);
INSERT INTO `goods` VALUES (10, '小米8 全面屏游戏智能拍照手机 6GB+128GB 黑色 骁龙845 全网通4G 双卡双待', 7199.00, 7199.00, 7199.00, 100, 0, '', NULL, '/uploads/goods/20190528/5b0fcbafNc30f70ec.jpg', 0, 2, 72, 0, NULL, NULL, '', 0, '0', 0, 1, 1, 1, 1, 1, 50, 0, '[{\"id\":\"7\",\"attr_name\":\"毛重\",\"attr_value\":\"180g\"},{\"id\":\"8\",\"attr_name\":\"产地\",\"attr_value\":\"中国\"}]', 1559054211, 1559054211, NULL);
INSERT INTO `goods` VALUES (11, 'Apple iPhone 7 (A1660) 128G 黑色 移动联通电信4G手机', 2699.00, 2699.00, 2699.00, 100, 0, '', NULL, '/uploads/goods/20190528/ab22cb8d8464e096.jpg', 0, 3, 72, 0, NULL, NULL, '', 0, '0', 0, 1, 1, 1, 1, 1, 50, 0, '[{\"id\":\"7\",\"attr_name\":\"毛重\",\"attr_value\":\"180g\"},{\"id\":\"8\",\"attr_name\":\"产地\",\"attr_value\":\"中国\"}]', 1559054211, 1559054211, NULL);
INSERT INTO `goods` VALUES (12, '华为 HUAWEI P20 AI智慧徕卡双摄全面屏游戏手机 6GB+64GB 极光色 全网通移动联通电信4G手机 双卡双待', 3899.00, 3899.00, 3899.00, 100, 0, '', NULL, '/uploads/goods/20190528/5af13917Naca6cb3d.jpg', 0, 1, 72, 0, NULL, NULL, '', 0, '0', 0, 1, 1, 1, 1, 1, 50, 0, '[{\"id\":\"7\",\"attr_name\":\"毛重\",\"attr_value\":\"180g\"},{\"id\":\"8\",\"attr_name\":\"产地\",\"attr_value\":\"中国\"}]', 1559054211, 1559054211, NULL);
INSERT INTO `goods` VALUES (13, 'Apple iPhone XS Max (A2103) 256GB 深空灰色 全网通（移动4G优先版） 双卡双待', 9899.00, 9899.00, 9899.00, 100, 0, '', NULL, '/uploads/goods/20190528/819dcf182d743897.jpg', 0, 3, 72, 0, NULL, NULL, '', 0, '0', 0, 1, 1, 1, 1, 1, 50, 0, '[{\"id\":\"7\",\"attr_name\":\"毛重\",\"attr_value\":\"180g\"},{\"id\":\"8\",\"attr_name\":\"产地\",\"attr_value\":\"中国\"}]', 1559054211, 1559054211, NULL);
INSERT INTO `goods` VALUES (14, '荣耀畅玩8C两天一充 莱茵护眼 刘海屏 全网通版4GB+32GB 幻夜黑 移动联通电信4G全面屏手机 双卡双待', 6699.00, 6699.00, 6699.00, 100, 0, '', NULL, '/uploads/goods/20190528/5bbac3c5N8b0bd22b.jpg', 0, 1, 72, 0, NULL, NULL, '', 0, '0', 0, 1, 1, 1, 1, 1, 50, 0, '[{\"id\":\"7\",\"attr_name\":\"毛重\",\"attr_value\":\"180g\"},{\"id\":\"8\",\"attr_name\":\"产地\",\"attr_value\":\"中国\"}]', 1559054211, 1559054211, NULL);
INSERT INTO `goods` VALUES (15, '华为 HUAWEI Mate 20 麒麟980AI智能芯片全面屏超微距影像超大广角徕卡三摄6GB+128GB亮黑色全网通版双4G手机', 9099.00, 9099.00, 9099.00, 100, 0, '', NULL, '/uploads/goods/20190528/5bbf1fc9N3ced3749.jpg', 0, 1, 72, 0, NULL, NULL, '', 0, '0', 0, 1, 1, 1, 1, 1, 50, 0, '[{\"id\":\"7\",\"attr_name\":\"毛重\",\"attr_value\":\"180g\"},{\"id\":\"8\",\"attr_name\":\"产地\",\"attr_value\":\"中国\"}]', 1559054211, 1559054211, NULL);
INSERT INTO `goods` VALUES (16, '小米 红米6A AI美颜 3GB+32GB 流沙金 全网通4G手机 双卡双待', 7199.00, 7199.00, 7199.00, 100, 0, '', NULL, '/uploads/goods/20190528/5b4edfdcN5a7d6faf.jpg', 0, 2, 72, 0, NULL, NULL, '', 0, '0', 0, 1, 1, 1, 1, 1, 50, 0, '[{\"id\":\"7\",\"attr_name\":\"毛重\",\"attr_value\":\"180g\"},{\"id\":\"8\",\"attr_name\":\"产地\",\"attr_value\":\"中国\"}]', 1559054211, 1559054211, NULL);
INSERT INTO `goods` VALUES (17, '【KPL官方比赛用机】vivo iQOO 44W超快闪充 8GB+128GB电光蓝 全面屏拍照手机 骁龙855电竞游戏 全网通4G手机', 6899.00, 6899.00, 6899.00, 100, 0, '', NULL, '/uploads/goods/20190528/044c52520956ebfb.jpg', 0, 8, 72, 0, NULL, NULL, '', 0, '0', 0, 1, 1, 1, 1, 1, 50, 0, '[{\"id\":\"7\",\"attr_name\":\"毛重\",\"attr_value\":\"180g\"},{\"id\":\"8\",\"attr_name\":\"产地\",\"attr_value\":\"中国\"}]', 1559054211, 1559054211, NULL);
INSERT INTO `goods` VALUES (18, 'Apple iPhone 8 Plus (A1864) 64GB 深空灰色 移动联通电信4G手机', 2499.00, 2499.00, 2499.00, 100, 0, '', NULL, '/uploads/goods/20190528/59b857f8N977f476c.jpg', 0, 3, 72, 0, NULL, NULL, '', 0, '0', 0, 1, 1, 1, 1, 1, 50, 0, '[{\"id\":\"7\",\"attr_name\":\"毛重\",\"attr_value\":\"180g\"},{\"id\":\"8\",\"attr_name\":\"产地\",\"attr_value\":\"中国\"}]', 1559054211, 1559054211, NULL);
INSERT INTO `goods` VALUES (19, '华为 HUAWEI 畅享9 Plus 4GB+64GB 极光紫 全网通 四摄超清全面屏大电池 移动联通电信4G手机 双卡双待', 5999.00, 5999.00, 5999.00, 100, 0, '', NULL, '/uploads/goods/20190528/5bbc6e01Ndf90871c.jpg', 0, 1, 72, 0, NULL, NULL, '', 0, '0', 0, 1, 1, 1, 1, 1, 50, 0, '[{\"id\":\"7\",\"attr_name\":\"毛重\",\"attr_value\":\"180g\"},{\"id\":\"8\",\"attr_name\":\"产地\",\"attr_value\":\"中国\"}]', 1559054211, 1559054211, NULL);
INSERT INTO `goods` VALUES (20, '小米 红米Redmi Note7Pro AI双摄 6GB+128GB 梦幻蓝 全网通4G 双卡双待 水滴屏拍照游戏手机', 3299.00, 3299.00, 3299.00, 100, 0, '', NULL, '/uploads/goods/20190528/9cd57e3a481c7160.jpg', 0, 2, 72, 0, NULL, NULL, '', 0, '0', 0, 1, 1, 1, 1, 1, 50, 0, '[{\"id\":\"7\",\"attr_name\":\"毛重\",\"attr_value\":\"180g\"},{\"id\":\"8\",\"attr_name\":\"产地\",\"attr_value\":\"中国\"}]', 1559054211, 1559054211, NULL);
INSERT INTO `goods` VALUES (21, 'Apple iPhone X (A1865) 64GB 深空灰色 移动联通电信4G手机', 6299.00, 6299.00, 6299.00, 100, 0, '', NULL, '/uploads/goods/20190528/59df2e7fN86c99a27.jpg', 0, 3, 72, 0, NULL, NULL, '', 0, '0', 0, 1, 1, 1, 1, 1, 50, 0, '[{\"id\":\"7\",\"attr_name\":\"毛重\",\"attr_value\":\"180g\"},{\"id\":\"8\",\"attr_name\":\"产地\",\"attr_value\":\"中国\"}]', 1559054211, 1559054211, NULL);
INSERT INTO `goods` VALUES (22, '荣耀20i 3200万AI自拍 超广角三摄 全网通版6GB+64GB 幻夜黑 移动联通电信4G全面屏手机 双卡双待', 9299.00, 9299.00, 9299.00, 100, 0, '', NULL, '/uploads/goods/20190528/5cdd1018N977740e5.jpg', 0, 1, 72, 0, NULL, NULL, '', 0, '0', 0, 1, 1, 1, 1, 1, 50, 0, '[{\"id\":\"7\",\"attr_name\":\"毛重\",\"attr_value\":\"180g\"},{\"id\":\"8\",\"attr_name\":\"产地\",\"attr_value\":\"中国\"}]', 1559054211, 1559054211, NULL);
INSERT INTO `goods` VALUES (23, '小米9 4800万超广角三摄 8GB+128GB全息幻彩蓝 骁龙855 全网通4G 双卡双待 水滴全面屏拍照游戏智能手机', 6399.00, 6399.00, 6399.00, 100, 0, '', NULL, '/uploads/goods/20190528/ce6c1dee969fb626.jpg', 0, 2, 72, 0, NULL, NULL, '', 0, '0', 0, 1, 1, 1, 1, 1, 50, 0, '[{\"id\":\"7\",\"attr_name\":\"毛重\",\"attr_value\":\"180g\"},{\"id\":\"8\",\"attr_name\":\"产地\",\"attr_value\":\"中国\"}]', 1559054211, 1559054211, NULL);
INSERT INTO `goods` VALUES (24, '小米MIX2S 全面屏游戏拍照手机 6GB+128GB 黑色 骁龙845处理器 全网通4G 陶瓷手机', 4299.00, 4299.00, 4299.00, 100, 0, '', NULL, '/uploads/goods/20190528/5ab9e7a8Nbc37a260.jpg', 0, 2, 72, 0, NULL, NULL, '', 0, '0', 0, 1, 1, 1, 1, 1, 50, 0, '[{\"id\":\"7\",\"attr_name\":\"毛重\",\"attr_value\":\"180g\"},{\"id\":\"8\",\"attr_name\":\"产地\",\"attr_value\":\"中国\"}]', 1559054211, 1559054211, NULL);
INSERT INTO `goods` VALUES (25, '小米 Redmi 7 AI双摄 3GB+32GB 亮黑色 全网通4G 双卡双待 水滴全面屏拍照游戏智能手机', 1999.00, 1999.00, 1999.00, 100, 0, '', NULL, '/uploads/goods/20190528/fb7b968a62eb10ef.jpg', 0, 2, 72, 0, NULL, NULL, '', 0, '0', 0, 1, 1, 1, 1, 1, 50, 0, '[{\"id\":\"7\",\"attr_name\":\"毛重\",\"attr_value\":\"180g\"},{\"id\":\"8\",\"attr_name\":\"产地\",\"attr_value\":\"中国\"}]', 1559054211, 1559054211, NULL);
INSERT INTO `goods` VALUES (26, '荣耀Play 全网通版 6GB+64GB 极光蓝 移动联通电信4G全面屏游戏手机 双卡双待', 9699.00, 9699.00, 9699.00, 100, 0, '', NULL, '/uploads/goods/20190528/bc57c7563eb82aa2.jpg', 0, 1, 72, 0, NULL, NULL, '', 0, '0', 0, 1, 1, 1, 1, 1, 50, 0, '[{\"id\":\"7\",\"attr_name\":\"毛重\",\"attr_value\":\"180g\"},{\"id\":\"8\",\"attr_name\":\"产地\",\"attr_value\":\"中国\"}]', 1559054211, 1559054211, NULL);
INSERT INTO `goods` VALUES (27, 'Apple iPhone 7 Plus (A1661) 128G 黑色 移动联通电信4G手机', 2199.00, 2199.00, 2199.00, 100, 0, '', NULL, '/uploads/goods/20190528/34ac75cc458efc46.jpg', 0, 3, 72, 0, NULL, NULL, '', 0, '0', 0, 1, 1, 1, 1, 1, 50, 0, '[{\"id\":\"7\",\"attr_name\":\"毛重\",\"attr_value\":\"180g\"},{\"id\":\"8\",\"attr_name\":\"产地\",\"attr_value\":\"中国\"}]', 1559054211, 1559054211, NULL);
INSERT INTO `goods` VALUES (28, '华为 HUAWEI 畅享9  4GB+64GB 幻夜黑 高清珍珠屏 AI长续航 全网通高配版 移动联通电信4G手机', 9799.00, 9799.00, 9799.00, 100, 0, '', NULL, '/uploads/goods/20190528/5c00df9bN52171b33.jpg', 0, 1, 72, 0, NULL, NULL, '', 0, '0', 0, 1, 1, 1, 1, 1, 50, 0, '[{\"id\":\"7\",\"attr_name\":\"毛重\",\"attr_value\":\"180g\"},{\"id\":\"8\",\"attr_name\":\"产地\",\"attr_value\":\"中国\"}]', 1559054211, 1559054211, NULL);
INSERT INTO `goods` VALUES (29, '小米6X 全网通 6GB+64GB 赤焰红 移动联通电信4G手机 双卡双待 智能手机 拍照手机', 4399.00, 4399.00, 4399.00, 100, 0, '', NULL, '/uploads/goods/20190528/5adfe5eaN42591f8c.jpg', 0, 2, 72, 0, NULL, NULL, '', 0, '0', 0, 1, 1, 1, 1, 1, 50, 0, '[{\"id\":\"7\",\"attr_name\":\"毛重\",\"attr_value\":\"180g\"},{\"id\":\"8\",\"attr_name\":\"产地\",\"attr_value\":\"中国\"}]', 1559054211, 1559054211, NULL);
INSERT INTO `goods` VALUES (30, '小米Play 流光渐变AI双摄 4GB+64GB 黑色 全网通4G 双卡双待 小水滴全面屏拍照游戏智能手机', 1199.00, 1199.00, 1199.00, 100, 0, '', NULL, '/uploads/goods/20190528/019c7ee866ded8f8.jpg', 0, 2, 72, 0, NULL, NULL, '', 0, '0', 0, 1, 1, 1, 1, 1, 50, 0, '[{\"id\":\"7\",\"attr_name\":\"毛重\",\"attr_value\":\"180g\"},{\"id\":\"8\",\"attr_name\":\"产地\",\"attr_value\":\"中国\"}]', 1559054211, 1559054211, NULL);
INSERT INTO `goods` VALUES (31, '华为 HUAWEI P20 Pro 全面屏徕卡三摄游戏手机 6GB+128GB 极光色 全网通移动联通电信4G手机 双卡双待', 7799.00, 7799.00, 7799.00, 100, 0, '', NULL, '/uploads/goods/20190528/5ac1eae4Nce7c8b00.jpg', 0, 1, 72, 0, NULL, NULL, '', 0, '0', 0, 1, 1, 1, 1, 1, 50, 0, '[{\"id\":\"7\",\"attr_name\":\"毛重\",\"attr_value\":\"180g\"},{\"id\":\"8\",\"attr_name\":\"产地\",\"attr_value\":\"中国\"}]', 1559054211, 1559054211, NULL);
INSERT INTO `goods` VALUES (32, '华为 HUAWEI 畅享 9S 6GB+64GB 幻夜黑 全网通 2400万超广角三摄珍珠屏大存储 移动联通电信4G手机 双卡双待', 8899.00, 8899.00, 8899.00, 100, 0, '', NULL, '/uploads/goods/20190528/46e7ace99f41dd41.jpg', 0, 1, 72, 0, NULL, NULL, '', 0, '0', 0, 1, 1, 1, 1, 1, 50, 0, '[{\"id\":\"7\",\"attr_name\":\"毛重\",\"attr_value\":\"180g\"},{\"id\":\"8\",\"attr_name\":\"产地\",\"attr_value\":\"中国\"}]', 1559054211, 1559054211, NULL);
INSERT INTO `goods` VALUES (33, '华为 HUAWEI Mate 20 Pro (UD)屏内指纹版麒麟980芯片全面屏超大广角徕卡三摄8GB+128GB亮黑色全网通双4G手机', 7199.00, 7199.00, 7199.00, 100, 0, '', NULL, '/uploads/goods/20190528/5bbf17f0N428d505a.jpg', 0, 1, 72, 0, NULL, NULL, '', 0, '0', 0, 1, 1, 1, 1, 1, 50, 0, '[{\"id\":\"7\",\"attr_name\":\"毛重\",\"attr_value\":\"180g\"},{\"id\":\"8\",\"attr_name\":\"产地\",\"attr_value\":\"中国\"}]', 1559054211, 1559054211, NULL);
COMMIT;

-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
  `id` int NOT NULL AUTO_INCREMENT,
  `role_name` varchar(30) COLLATE utf8mb4_german2_ci DEFAULT NULL COMMENT '角色名称',
  `create_at` int DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_german2_ci;

-- ----------------------------
-- Records of role
-- ----------------------------
BEGIN;
INSERT INTO `role` VALUES (1, '项目经理', NULL);
INSERT INTO `role` VALUES (2, '开发人员', NULL);
COMMIT;

-- ----------------------------
-- Table structure for role_auth
-- ----------------------------
DROP TABLE IF EXISTS `role_auth`;
CREATE TABLE `role_auth` (
  `role_id` int DEFAULT NULL COMMENT '角色id',
  `auth_id` int DEFAULT NULL COMMENT '权限id'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_german2_ci;

-- ----------------------------
-- Records of role_auth
-- ----------------------------
BEGIN;
INSERT INTO `role_auth` VALUES (1, 2);
INSERT INTO `role_auth` VALUES (1, 1);
INSERT INTO `role_auth` VALUES (1, 3);
INSERT INTO `role_auth` VALUES (1, 4);
INSERT INTO `role_auth` VALUES (2, 4);
INSERT INTO `role_auth` VALUES (1, 5);
INSERT INTO `role_auth` VALUES (1, 6);
INSERT INTO `role_auth` VALUES (1, 7);
INSERT INTO `role_auth` VALUES (1, 8);
INSERT INTO `role_auth` VALUES (2, 5);
INSERT INTO `role_auth` VALUES (2, 6);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
